How to: Find and delete duplicate records in a table.

Solution:


Use the query wizard to find the duplicate records; then create a new table, set the duplicate records as primary fields, and append a query based on the original table to the copy.